package uk.ac.lkl.takteen.energyapp.data;

public class EnergyAppDatabaseMetadata {

	// table names; the challenges created by the user, the
	// pledges made by the user, the challenges received from others
	public static final String USER_CHALLENGES_TABLE_NAME = "userChallenges";
	public static final String USER_PLEDGES_TABLE_NAME = "userPledges";
	public static final String RECEIVED_CHALLENGES_TABLE_NAME = "receivedChallenges";
	public static final String SHARED_PLEDGES_TABLE_NAME = "sharedPledges";

	// general table attributes
	public static final String _ID = "_id";
	public static final String CREATED_BY = "createdBy";

	// user's challenges table attributes
	public static final String CHALLENGE_NAME = "challengeName";
	public static final String LAST_MODIFIED_BY = "lastModifiedBy";
	public static final String DATE_CREATED = "dateCreated";
	public static final String CHALLENGE_TYPE = "challengeType";
	public static final String CHALLENGE_TYPE_POS = "challengeTypePos";
	public static final String ENERGY_TYPE = "energyType";
	public static final String ENERGY_TYPE_POS = "energyTypePos";
	public static final String CHALLENGE_IMAGE = "challengeImage";
	public static final String CHALLENGE_INFO = "challengeInfo";
	public static final String CHALLENGE_LINK = "challengeLink";

	// received challenges
	public static final String SENT_BY = "sentBy";

	// user's pledges table attributes
	public static final String PLEDGE_NAME = "pledgeName";
	public static final String EXPIRATION_YEAR = "expirationYear";
	public static final String EXPIRATION_MONTH = "expirationMonth";
	public static final String EXPIRATION_DAY = "expirationDay";
	public static final String NUM_TIMES_RENEWED = "numRenews";
	public static final String WHEN_STATEMENT = "whenStatement";
	public static final String THEN_STATEMENT = "thenStatement";
	public static final String KUDOS = "kudos";

	// shared pledges
	public static final String PLEDGE_IMAGE = "pledgeImage";

	public static final String[] PROJECTION_USER_PLEDGES = new String[] {
			EnergyAppDatabaseMetadata._ID, // 0
			EnergyAppDatabaseMetadata.PLEDGE_NAME, // 1
			EnergyAppDatabaseMetadata.CREATED_BY, // 2
			EnergyAppDatabaseMetadata.DATE_CREATED, // 3
			EnergyAppDatabaseMetadata.WHEN_STATEMENT, // 4
			EnergyAppDatabaseMetadata.THEN_STATEMENT, // 5
			EnergyAppDatabaseMetadata.EXPIRATION_YEAR, // 6
			EnergyAppDatabaseMetadata.EXPIRATION_MONTH, // 7
			EnergyAppDatabaseMetadata.EXPIRATION_DAY, // 8
	};

	public static final String[] PROJECTION_SHARED_PLEDGES = new String[] {
			EnergyAppDatabaseMetadata._ID, // 0
			EnergyAppDatabaseMetadata.PLEDGE_NAME, // 1
			EnergyAppDatabaseMetadata.PLEDGE_IMAGE, // 2
	};

	public static final String[] PROJECTION_RECEIVED_CHALLENGES = new String[] {
			EnergyAppDatabaseMetadata._ID,
			EnergyAppDatabaseMetadata.CHALLENGE_NAME,
			// EnergyAppDatabaseMetadata.CREATED_BY,
			// EnergyAppDatabaseMetadata.LAST_MODIFIED_BY,
			// EnergyAppDatabaseMetadata.CHALLENGE_TYPE,
			// EnergyAppDatabaseMetadata.CHALLENGE_TYPE_POS,
			// EnergyAppDatabaseMetadata.ENERGY_TYPE,
			// EnergyAppDatabaseMetadata.ENERGY_TYPE_POS,
			// EnergyAppDatabaseMetadata.MOTIVATIONAL_MSG,
			EnergyAppDatabaseMetadata.CHALLENGE_IMAGE
	// EnergyAppDatabaseMetadata.CHALLENGE_INFO,
	// EnergyAppDatabaseMetadata.CHALLENGE_LINK
	};

	public static final String[] PROJECTION_USER_CHALLENGES = new String[] {
			EnergyAppDatabaseMetadata._ID,
			EnergyAppDatabaseMetadata.CHALLENGE_NAME,
			EnergyAppDatabaseMetadata.CREATED_BY,
			EnergyAppDatabaseMetadata.LAST_MODIFIED_BY,
			EnergyAppDatabaseMetadata.CHALLENGE_TYPE,
			EnergyAppDatabaseMetadata.CHALLENGE_TYPE_POS,
			EnergyAppDatabaseMetadata.ENERGY_TYPE,
			EnergyAppDatabaseMetadata.ENERGY_TYPE_POS,
			EnergyAppDatabaseMetadata.CHALLENGE_IMAGE,
			EnergyAppDatabaseMetadata.CHALLENGE_INFO,
			EnergyAppDatabaseMetadata.CHALLENGE_LINK };
}
